<%-- 
    Document   : EXTRA
    Created on : Jun 20, 2012, 2:54:44 PM
    Author     : praneeth
--%>
<%-- 
    Document   : UpdateAcc
    Created on : Jun 12, 2012, 7:49:56 PM
    Author     : praneeth
--%>

<%@page import="java.sql.*" %>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" href="style.css" />
<title>Well Come To Update</title>
<style type="text/css">
td {color:white}
legend{color:white}
<!--
.style1 {font-size: medium}
-->
</style></head>
<body>
<div id="container">
 <div id="header">
       	<h2>E Gas Sewa</h2>
 <div id="footer">
        <h6>Copyright © MIPGS09-12 org</h6></div></div>   
 <div id="menu">
        	<ul>
            	<li class="menuitem"><a href="ConsumerPage.jsp">Home</a></li>
                <li class="menuitem"><a href="#">About</a></li>
                <li class="menuitem"><a href="#">Products</a></li>
                <li class="menuitem"><a href="#">Services</a></li>
                <li class="menuitem"><a href="#">Contact</a></li>
                </ul>
</div>
<div id="table">
    <form action="update_accstore.jsp" >
      <table>
                <% 
       
          try{   
               Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");  
               String a=session.getAttribute("userid").toString();
                 String q1="select * from AccCreation where userid='"+a+"'";
       
       
        Connection connection = DriverManager.getConnection("jdbc:odbc:egasdsn");
        Statement stmt =connection.createStatement();       
        ResultSet rs =stmt.executeQuery(q1);
         if(rs.next()){
                String userid=rs.getString(1);
                String fname=rs.getString(2);
                String lname=rs.getString(3);
                String uid=rs.getString(4);
                String pwd=rs.getString(5);
                String cpwd=rs.getString(6);
                String faname=rs.getString(7);
                String hq=rs.getString(8);
                String ha=rs.getString(9);
                String gen=rs.getString(10);
                String mbno=rs.getString(12);
                String eid=rs.getString(13);
                String add=rs.getString(14);
                String area=rs.getString(15);
                String pin=rs.getString(16);
                               %>
   
         <tr><td></td><td><input type="hidden" name="uniq_id" value='<%=  userid%>' disabled="true"></td></tr>
         <tr><td></td><td><input type="hidden" name="fname" value="<%= fname%>" disabled="true"></td>
         <td><input type="hidden" name="lname" value="<%= lname%>" disabled="true"></td><tr>
         <tr><td></td><td><input type="hidden" name="uid" value="<%= uid%>"></td></tr>
         <tr><td>pwd:</td><td> <input type="password" name="pwd" value="<%= pwd%>"></td>
         <td>cpwd: <input type="password" name="cpwd" value="<%= cpwd%>"></td></tr>
         <tr><td>fathername:</td><td><input type="text" name="fathername" value="<%= faname%>" disabled="true" ></td></tr>
         <tr><td>hq:</td><td><input type="text" name="HQ" value="<%= hq%>"></td></tr><br/>
         <tr><td>ha:</td><td> <input type="text" name="HA" value="<%= ha%>"></td></tr><br/>
         <tr><td>gender:</td><td><input type="text" name="gender" value="<%= gen%>" disabled="true"></td></tr>
         <tr><td>mbno:</td><td><input type="text" name="mbno" value="<%= mbno%>"></td></tr>
         <tr><td>Eid:</td><td><input type="text" name="eid" value="<%= eid%>"></td></tr>
         <tr><td>add:</td><td><input type="text" name="add" value="<%= add%>"></td></tr>
         <tr><td>area:</td><td><input type="text" name="area" value="<%= area%>"></td></tr>
         <tr><td>pin:</td><td><input type="text" name="pin" value="<%= pin%>"></td></tr>
          <tr></tr>
   <tr></tr>
   <tr><td><td><td><input type="SUBMIT" value="SUBMIT">
                       <td><input type="reset" value="RESET" /><td></td></td></tr> 
   
       <%               
            }
               
               }catch(Exception e){
        }

    %>
    </table>
	 	 	</form>
	  
     </div>
</body>
</html>